<?php

/**
 *经销商查询发布
 */
$sql = "
CREATE TABLE IF NOT EXISTS " . tablename('tim_dealer') . " (
`id` int(10) unsigned  AUTO_INCREMENT,
`uniacid` int(11) NOT NULL,
`company` varchar(50) NOT NULL,
`province` varchar(20) NOT NULL,
`city` varchar(20) NOT NULL,
`address` varchar(100) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;";
pdo_query($sql);

$sql = "
CREATE TABLE IF NOT EXISTS " . tablename('tim_dealersetting') . " (
`id` int(10) unsigned  AUTO_INCREMENT,
`uniacid` int(11) NOT NULL,
`title` varchar(40) NOT NULL,
`page_cover` varchar(200), 
`copyright` varchar(100),
`share_title` varchar(100),
`share_icon` varchar(200),
`share_content` varchar(200),
 PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;";
pdo_query($sql);

$sql = "
CREATE TABLE IF NOT EXISTS " . tablename('tim_dealerppt') . " (
`id` int(10) unsigned  AUTO_INCREMENT,
`uniacid` int(11) NOT NULL,
`picture` varchar(200),
`pic_intro` varchar(100),
`url` varchar(100),
 PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;";
pdo_query($sql);





